Pandas Profiling Report

Dataset statistics

Number of variables	25
Number of observations	56000
Missing cells	229986
Missing cells (%)	16.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.7 MiB
Average record size in memory	200.0 B

Variable types

Categorical	1
Numeric	24

Alerts

`Applicant_ID` has a high cardinality: 56000 distinct values	High cardinality
`form_field1` is highly correlated with `form_field3` and 2 other fields	High correlation
`form_field3` is highly correlated with `form_field5`	High correlation
`form_field6` is highly correlated with `form_field16` and 5 other fields	High correlation
`form_field7` is highly correlated with `form_field10`	High correlation
`form_field8` is highly correlated with `form_field1` and 3 other fields	High correlation
`form_field9` is highly correlated with `form_field8` and 1 other fields	High correlation
`form_field10` is highly correlated with `form_field7` and 1 other fields	High correlation
`form_field12` is highly correlated with `form_field13`	High correlation
`form_field13` is highly correlated with `form_field10`	High correlation
`form_field16` is highly correlated with `form_field17` and 1 other fields	High correlation
`form_field17` is highly correlated with `form_field16` and 3 other fields	High correlation
`form_field18` is highly correlated with `form_field16` and 3 other fields	High correlation
`form_field19` is highly correlated with `form_field17` and 2 other fields	High correlation
`form_field20` is highly correlated with `form_field17` and 2 other fields	High correlation
`form_field21` is highly correlated with `form_field22` and 1 other fields	High correlation
`form_field22` is highly correlated with `form_field21` and 1 other fields	High correlation
`form_field23` is highly correlated with `form_field21` and 1 other fields	High correlation
`form_field24` is highly correlated with `form_field19` and 4 other fields	High correlation
`form_field5` is highly correlated with `form_field3`	High correlation
`form_field1` has 2529 (4.5%) missing values	Missing
`form_field2` has 3844 (6.9%) missing values	Missing
`form_field6` has 13360 (23.9%) missing values	Missing
`form_field7` has 5163 (9.2%) missing values	Missing
`form_field8` has 13360 (23.9%) missing values	Missing
`form_field9` has 8008 (14.3%) missing values	Missing
`form_field11` has 31421 (56.1%) missing values	Missing
`form_field12` has 9895 (17.7%) missing values	Missing
`form_field13` has 5889 (10.5%) missing values	Missing
`form_field15` has 22475 (40.1%) missing values	Missing
`form_field16` has 13036 (23.3%) missing values	Missing
`form_field17` has 11151 (19.9%) missing values	Missing
`form_field18` has 10402 (18.6%) missing values	Missing
`form_field21` has 15854 (28.3%) missing values	Missing
`form_field22` has 20400 (36.4%) missing values	Missing
`form_field23` has 28123 (50.2%) missing values	Missing
`form_field24` has 13297 (23.7%) missing values	Missing
`form_field7` is highly skewed (γ1 = 36.55604546)	Skewed
`form_field13` is highly skewed (γ1 = 53.66765836)	Skewed
`form_field14` is highly skewed (γ1 = 118.5474777)	Skewed
`form_field24` is highly skewed (γ1 = 30.44013754)	Skewed
`Applicant_ID` is uniformly distributed	Uniform
`Applicant_ID` has unique values	Unique
`form_field2` has 4453 (8.0%) zeros	Zeros
`form_field3` has 25728 (45.9%) zeros	Zeros
`form_field4` has 47900 (85.5%) zeros	Zeros
`form_field5` has 50322 (89.9%) zeros	Zeros
`form_field6` has 7454 (13.3%) zeros	Zeros
`form_field7` has 2083 (3.7%) zeros	Zeros
`form_field8` has 1772 (3.2%) zeros	Zeros
`form_field10` has 7190 (12.8%) zeros	Zeros
`form_field12` has 3583 (6.4%) zeros	Zeros
`form_field13` has 9016 (16.1%) zeros	Zeros
`form_field14` has 1446 (2.6%) zeros	Zeros
`form_field16` has 35943 (64.2%) zeros	Zeros
`form_field17` has 36859 (65.8%) zeros	Zeros
`form_field18` has 37265 (66.5%) zeros	Zeros
`form_field19` has 33598 (60.0%) zeros	Zeros
`form_field20` has 31471 (56.2%) zeros	Zeros
`form_field22` has 5205 (9.3%) zeros	Zeros
`form_field23` has 4785 (8.5%) zeros	Zeros
`form_field24` has 3262 (5.8%) zeros	Zeros

Reproduction

Analysis started	2022-10-20 13:50:59.330123
Analysis finished	2022-10-20 13:55:24.709351
Duration	4 minutes and 25.38 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

Applicant_ID
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	56000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	437.6 KiB

Apcnt_1070960	1
Apcnt_1102324	1
Apcnt_957156	1
Apcnt_1175268	1
Apcnt_1090040	1
Other values (55995)	55995

Length

Max length	13
Median length	13
Mean length	12.74910714
Min length	12

Characters and Unicode

Total characters	713950
Distinct characters	16
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	56000 ?
Unique (%)	100.0%

Sample

1st row	Apcnt_1000000
2nd row	Apcnt_1000004
3rd row	Apcnt_1000008
4th row	Apcnt_1000012
5th row	Apcnt_1000016

Common Values

Value	Count	Frequency (%)
Apcnt_1070960	1	< 0.1%
Apcnt_1102324	1	< 0.1%
Apcnt_957156	1	< 0.1%
Apcnt_1175268	1	< 0.1%
Apcnt_1090040	1	< 0.1%
Apcnt_1214232	1	< 0.1%
Apcnt_1010604	1	< 0.1%
Apcnt_1166812	1	< 0.1%
Apcnt_1191144	1	< 0.1%
Apcnt_949060	1	< 0.1%
Other values (55990)	55990	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
apcnt_1070960	1	< 0.1%
apcnt_1040964	1	< 0.1%
apcnt_1229416	1	< 0.1%
apcnt_1149264	1	< 0.1%
apcnt_1099360	1	< 0.1%
apcnt_1024660	1	< 0.1%
apcnt_1208636	1	< 0.1%
apcnt_1137564	1	< 0.1%
apcnt_1192808	1	< 0.1%
apcnt_1094936	1	< 0.1%
Other values (55990)	55990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	80441	11.3%
A	56000	7.8%
p	56000	7.8%
c	56000	7.8%
n	56000	7.8%
t	56000	7.8%
_	56000	7.8%
0	51761	7.2%
2	43067	6.0%
9	35127	4.9%
Other values (6)	167554	23.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	377950	52.9%
Lowercase Letter	224000	31.4%
Uppercase Letter	56000	7.8%
Connector Punctuation	56000	7.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	80441	21.3%
0	51761	13.7%
2	43067	11.4%
9	35127	9.3%
6	34407	9.1%
4	34375	9.1%
8	34316	9.1%
3	22704	6.0%
5	20902	5.5%
7	20850	5.5%

Lowercase Letter

Value	Count	Frequency (%)
p	56000	25.0%
c	56000	25.0%
n	56000	25.0%
t	56000	25.0%

Uppercase Letter

Value	Count	Frequency (%)
A	56000	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	56000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	433950	60.8%
Latin	280000	39.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	80441	18.5%
_	56000	12.9%
0	51761	11.9%
2	43067	9.9%
9	35127	8.1%
6	34407	7.9%
4	34375	7.9%
8	34316	7.9%
3	22704	5.2%
5	20902	4.8%

Latin

Value	Count	Frequency (%)
A	56000	20.0%
p	56000	20.0%
c	56000	20.0%
n	56000	20.0%
t	56000	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	713950	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	80441	11.3%
A	56000	7.8%
p	56000	7.8%
c	56000	7.8%
n	56000	7.8%
t	56000	7.8%
_	56000	7.8%
0	51761	7.2%
2	43067	6.0%
9	35127	4.9%
Other values (6)	167554	23.5%

form_field1
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	449
Distinct (%)	0.8%
Missing	2529
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	3491.795665

Minimum	2990
Maximum	3900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	2990
5-th percentile	3184
Q1	3358
median	3484
Q3	3620
95-th percentile	3824
Maximum	3900
Range	910
Interquartile range (IQR)	262

Descriptive statistics

Standard deviation	188.4624264
Coefficient of variation (CV)	0.05397292525
Kurtosis	-0.6137862183
Mean	3491.795665
Median Absolute Deviation (MAD)	130
Skewness	0.1204580689
Sum	186709806
Variance	35518.08617
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3472	318	0.6%
3488	311	0.6%
3518	304	0.5%
3502	293	0.5%
3474	277	0.5%
3514	270	0.5%
3456	270	0.5%
3424	269	0.5%
3378	265	0.5%
3440	261	0.5%
Other values (439)	50633	90.4%
(Missing)	2529	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2990	1	< 0.1%
2994	1	< 0.1%
2998	2	< 0.1%
3000	1	< 0.1%
3004	1	< 0.1%
3008	1	< 0.1%
3010	3	< 0.1%
3012	2	< 0.1%
3016	1	< 0.1%
3020	1	< 0.1%

Value	Count	Frequency (%)
3900	185	0.3%
3898	26	< 0.1%
3896	22	< 0.1%
3894	34	0.1%
3892	25	< 0.1%
3890	35	0.1%
3888	23	< 0.1%
3886	41	0.1%
3884	35	0.1%
3882	41	0.1%

form_field2
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	20015
Distinct (%)	38.4%
Missing	3844
Missing (%)	6.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.5507368491

Minimum	0
Maximum	18.01505
Zeros	4453
Zeros (%)	8.0%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.0707875
median	0.267575
Q3	0.7195125
95-th percentile	1.9649375
Maximum	18.01505
Range	18.01505
Interquartile range (IQR)	0.648725

Descriptive statistics

Standard deviation	0.8209791851
Coefficient of variation (CV)	1.490692309
Kurtosis	34.35300741
Mean	0.5507368491
Median Absolute Deviation (MAD)	0.23575
Skewness	4.299532086
Sum	28724.2311
Variance	0.6740068224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4453	8.0%
0.68005	181	0.3%
0.09505	171	0.3%
0.19505	153	0.3%
0.06505	149	0.3%
0.19005	146	0.3%
0.04755	141	0.3%
0.0634	139	0.2%
0.29255	138	0.2%
0.09755	137	0.2%
Other values (20005)	46348	82.8%
(Missing)	3844	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4453	8.0%
0.0013	1	< 0.1%
0.0014	1	< 0.1%
0.00155	1	< 0.1%
0.00195	4	< 0.1%
0.00215	1	< 0.1%
0.0022	2	< 0.1%
0.0023	1	< 0.1%
0.00235	3	< 0.1%
0.00255	3	< 0.1%

Value	Count	Frequency (%)
18.01505	1	< 0.1%
14.23635	1	< 0.1%
14.02645	1	< 0.1%
12.85645	1	< 0.1%
12.37005	1	< 0.1%
12.3536	1	< 0.1%
12.2317	1	< 0.1%
12.21065	1	< 0.1%
12.13865	1	< 0.1%
12.1248	1	< 0.1%

form_field3
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	14617
Distinct (%)	26.3%
Missing	355
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.052225041

Minimum	0
Maximum	57.3716
Zeros	25728
Zeros (%)	45.9%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.062
Q3	1.282
95-th percentile	5.17856
Maximum	57.3716
Range	57.3716
Interquartile range (IQR)	1.282

Descriptive statistics

Standard deviation	2.147767914
Coefficient of variation (CV)	2.04116784
Kurtosis	33.55653924
Mean	1.052225041
Median Absolute Deviation (MAD)	0.062
Skewness	4.233351065
Sum	58551.0624
Variance	4.612907013
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25728	45.9%
1.5828	238	0.4%
1.4132	186	0.3%
0.104	154	0.3%
1.1776	145	0.3%
0.06	144	0.3%
0.0402	143	0.3%
0.09	136	0.2%
1.1872	134	0.2%
0.0636	124	0.2%
Other values (14607)	28513	50.9%
(Missing)	355	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25728	45.9%
0.0268	55	0.1%
0.0276	14	< 0.1%
0.0284	10	< 0.1%
0.0292	15	< 0.1%
0.03	21	< 0.1%
0.031	10	< 0.1%
0.0314	3	< 0.1%
0.0322	26	< 0.1%
0.033	4	< 0.1%

Value	Count	Frequency (%)
57.3716	1	< 0.1%
38.5066	1	< 0.1%
36.69	1	< 0.1%
34.6878	1	< 0.1%
31.9168	1	< 0.1%
30.0506	1	< 0.1%
29.5446	1	< 0.1%
28.4726	1	< 0.1%
27.586	1	< 0.1%
27.4838	1	< 0.1%

form_field4
Real number (ℝ_≥0)

ZEROS

Distinct	2927
Distinct (%)	5.3%
Missing	355
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.8519789307

Minimum	0
Maximum	91.6722
Zeros	47900
Zeros (%)	85.5%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	6.32664
Maximum	91.6722
Range	91.6722
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.157692009
Coefficient of variation (CV)	3.706302933
Kurtosis	45.48865411
Mean	0.8519789307
Median Absolute Deviation (MAD)	0
Skewness	5.427309707
Sum	47408.3676
Variance	9.971018827
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	47900	85.5%
13.779	645	1.2%
1.0404	139	0.2%
12.4272	117	0.2%
0.9	116	0.2%
0.4032	100	0.2%
0.8046	98	0.2%
15.4332	91	0.2%
0.6372	88	0.2%
0.5004	71	0.1%
Other values (2917)	6280	11.2%
(Missing)	355	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	47900	85.5%
0.4032	100	0.2%
0.414	65	0.1%
0.4248	55	0.1%
0.4374	69	0.1%
0.45	66	0.1%
0.4644	50	0.1%
0.4806	63	0.1%
0.5004	71	0.1%
0.5202	53	0.1%

Value	Count	Frequency (%)
91.6722	1	< 0.1%
67.1004	1	< 0.1%
46.3572	1	< 0.1%
46.1826	1	< 0.1%
43.5294	1	< 0.1%
42.7482	1	< 0.1%
41.958	1	< 0.1%
41.3352	3	< 0.1%
40.8114	1	< 0.1%
39.9834	3	< 0.1%

form_field5
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	2991
Distinct (%)	5.4%
Missing	355
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.956316762

Minimum	0
Maximum	407.7486
Zeros	50322
Zeros (%)	89.9%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	10.9764
Maximum	407.7486
Range	407.7486
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.5123958
Coefficient of variation (CV)	5.373565267
Kurtosis	173.9818866
Mean	1.956316762
Median Absolute Deviation (MAD)	0
Skewness	10.46519156
Sum	108859.2462
Variance	110.5104655
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	50322	89.9%
12.7188	160	0.3%
14.2452	121	0.2%
25.4376	82	0.1%
0.9666	47	0.1%
0.4824	47	0.1%
28.4922	41	0.1%
0.9792	35	0.1%
1.4886	32	0.1%
1.2474	30	0.1%
Other values (2981)	4728	8.4%
(Missing)	355	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	50322	89.9%
0.2412	5	< 0.1%
0.2484	2	< 0.1%
0.2556	2	< 0.1%
0.2628	2	< 0.1%
0.27	2	< 0.1%
0.279	2	< 0.1%
0.2898	2	< 0.1%
0.3006	1	< 0.1%
0.3114	1	< 0.1%

Value	Count	Frequency (%)
407.7486	1	< 0.1%
322.6986	1	< 0.1%
312.1902	1	< 0.1%
248.5404	1	< 0.1%
238.05	1	< 0.1%
235.0404	1	< 0.1%
234.9756	1	< 0.1%
232.1388	1	< 0.1%
228.7746	1	< 0.1%
224.937	1	< 0.1%

form_field6
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	5846
Distinct (%)	13.7%
Missing	13360
Missing (%)	23.9%
Infinite	0
Infinite (%)	0.0%
Mean	624447.9244

Minimum	0
Maximum	53135455
Zeros	7454
Zeros (%)	13.3%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	14004
median	115533
Q3	525928
95-th percentile	3083992
Maximum	53135455
Range	53135455
Interquartile range (IQR)	511924

Descriptive statistics

Standard deviation	1433421.545
Coefficient of variation (CV)	2.295502136
Kurtosis	87.67809769
Mean	624447.9244
Median Absolute Deviation (MAD)	115533
Skewness	6.203867089
Sum	2.66264595 × 10¹⁰
Variance	2.054697325 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7454	13.3%
192944	1670	3.0%
115533	1009	1.8%
385499	687	1.2%
770998	456	0.8%
1927495	354	0.6%
963942	318	0.6%
1156497	313	0.6%
578443	307	0.5%
394835	276	0.5%
Other values (5836)	29796	53.2%
(Missing)	13360	23.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7454	13.3%
389	141	0.3%
778	120	0.2%
1167	95	0.2%
1556	111	0.2%
1945	90	0.2%
2334	86	0.2%
2723	104	0.2%
3112	86	0.2%
3501	84	0.1%

Value	Count	Frequency (%)
53135455	1	< 0.1%
34183375	1	< 0.1%
33217877	1	< 0.1%
28526926	1	< 0.1%
21162767	1	< 0.1%
20202715	1	< 0.1%
19274950	1	< 0.1%
19268726	1	< 0.1%
19242663	1	< 0.1%
18858720	1	< 0.1%

form_field7
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	23199
Distinct (%)	45.6%
Missing	5163
Missing (%)	9.2%
Infinite	0
Infinite (%)	0.0%
Mean	6865210.385

Minimum	0
Maximum	2158794400
Zeros	2083
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	10892
Q1	686974
median	2704328
Q3	6993831
95-th percentile	25100614
Maximum	2158794400
Range	2158794400
Interquartile range (IQR)	6306857

Descriptive statistics

Standard deviation	19127287.28
Coefficient of variation (CV)	2.786118154
Kurtosis	3351.298103
Mean	6865210.385
Median Absolute Deviation (MAD)	2415301
Skewness	36.55604546
Sum	3.490067003 × 10¹¹
Variance	3.658531188 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2083	3.7%
192944	335	0.6%
115533	299	0.5%
1927495	253	0.5%
770998	240	0.4%
3854990	218	0.4%
5782485	208	0.4%
385499	207	0.4%
1156497	205	0.4%
7709980	191	0.3%
Other values (23189)	46598	83.2%
(Missing)	5163	9.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2083	3.7%
389	35	0.1%
778	15	< 0.1%
1167	19	< 0.1%
1556	16	< 0.1%
1945	16	< 0.1%
2334	16	< 0.1%
2723	20	< 0.1%
3112	18	< 0.1%
3501	11	< 0.1%

Value	Count	Frequency (%)
2158794400	1	< 0.1%
811231881	1	< 0.1%
749795555	1	< 0.1%
578248500	2	< 0.1%
486241442	1	< 0.1%
454760061	1	< 0.1%
385506002	1	< 0.1%
385499000	3	< 0.1%
381140255	1	< 0.1%
364797587	1	< 0.1%

form_field8
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	12820
Distinct (%)	30.1%
Missing	13360
Missing (%)	23.9%
Infinite	0
Infinite (%)	0.0%
Mean	2626690.178

Minimum	0
Maximum	103739687
Zeros	1772
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	3890
Q1	192944
median	963942
Q3	3751516
95-th percentile	9984463
Maximum	103739687
Range	103739687
Interquartile range (IQR)	3558572

Descriptive statistics

Standard deviation	3927354.753
Coefficient of variation (CV)	1.495172437
Kurtosis	41.46157334
Mean	2626690.178
Median Absolute Deviation (MAD)	917651
Skewness	3.935070239
Sum	1.120020692 × 10¹¹
Variance	1.542411535 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1772	3.2%
192944	663	1.2%
770998	526	0.9%
1927495	452	0.8%
385499	438	0.8%
115533	400	0.7%
1156497	397	0.7%
5782485	337	0.6%
3854990	329	0.6%
578443	308	0.5%
Other values (12810)	37018	66.1%
(Missing)	13360	23.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1772	3.2%
389	48	0.1%
778	40	0.1%
1167	37	0.1%
1556	45	0.1%
1945	38	0.1%
2334	38	0.1%
2723	47	0.1%
3112	32	0.1%
3501	23	< 0.1%

Value	Count	Frequency (%)
103739687	1	< 0.1%
102293774	1	< 0.1%
70757933	1	< 0.1%
62989992	1	< 0.1%
61587647	1	< 0.1%
60920123	1	< 0.1%
59752345	1	< 0.1%
58942058	1	< 0.1%
58749892	1	< 0.1%
55204157	1	< 0.1%

form_field9
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	22650
Distinct (%)	47.2%
Missing	8008
Missing (%)	14.3%
Infinite	0
Infinite (%)	0.0%
Mean	13160015.44

Minimum	0
Maximum	320053251
Zeros	246
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	154044
Q1	1368502
median	5506295
Q3	16945520.75
95-th percentile	51143911.15
Maximum	320053251
Range	320053251
Interquartile range (IQR)	15577018.75

Descriptive statistics

Standard deviation	19779632.55
Coefficient of variation (CV)	1.503009829
Kurtosis	21.12006954
Mean	13160015.44
Median Absolute Deviation (MAD)	4982895.5
Skewness	3.503331255
Sum	6.315754609 × 10¹¹
Variance	3.912338638 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
115533	846	1.5%
192944	678	1.2%
385499	388	0.7%
96472	283	0.5%
308477	265	0.5%
578443	256	0.5%
77022	254	0.5%
231455	250	0.4%
0	246	0.4%
770998	218	0.4%
Other values (22640)	44308	79.1%
(Missing)	8008	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	246	0.4%
389	1	< 0.1%
778	1	< 0.1%
1167	1	< 0.1%
1945	5	< 0.1%
2334	1	< 0.1%
5835	2	< 0.1%
6613	1	< 0.1%
14782	1	< 0.1%
15949	1	< 0.1%

Value	Count	Frequency (%)
320053251	1	< 0.1%
318657908	1	< 0.1%
312973451	1	< 0.1%
283626513	1	< 0.1%
273184975	1	< 0.1%
263025851	1	< 0.1%
262142043	1	< 0.1%
247754878	1	< 0.1%
244372523	1	< 0.1%
239569929	1	< 0.1%

form_field10
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	30942
Distinct (%)	55.6%
Missing	355
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	11855849.97

Minimum	0
Maximum	2191361480
Zeros	7190
Zeros (%)	12.8%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	450073
median	3707559
Q3	13261010
95-th percentile	48278867.8
Maximum	2191361480
Range	2191361480
Interquartile range (IQR)	12810937

Descriptive statistics

Standard deviation	26694592.88
Coefficient of variation (CV)	2.251596717
Kurtosis	981.2401314
Mean	11855849.97
Median Absolute Deviation (MAD)	3704447
Skewness	18.00742293
Sum	6.597187718 × 10¹¹
Variance	7.126012892 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7190	12.8%
115533	184	0.3%
192944	153	0.3%
77022	53	0.1%
385499	53	0.1%
770998	43	0.1%
38511	42	0.1%
308477	41	0.1%
578443	36	0.1%
154044	35	0.1%
Other values (30932)	47815	85.4%
(Missing)	355	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7190	12.8%
389	34	0.1%
778	19	< 0.1%
1167	17	< 0.1%
1556	13	< 0.1%
1945	17	< 0.1%
2334	14	< 0.1%
2723	19	< 0.1%
3112	17	< 0.1%
3501	15	< 0.1%

Value	Count	Frequency (%)
2191361480	1	< 0.1%
1184648541	1	< 0.1%
877379386	1	< 0.1%
852792252	1	< 0.1%
784120915	1	< 0.1%
759433030	1	< 0.1%
719533300	1	< 0.1%
640419258	1	< 0.1%
592858562	1	< 0.1%
524173221	1	< 0.1%

form_field11
Real number (ℝ_≥0)

MISSING

Distinct	9508
Distinct (%)	38.7%
Missing	31421
Missing (%)	56.1%
Infinite	0
Infinite (%)	0.0%
Mean	2054714.76

Minimum	0
Maximum	170742992
Zeros	58
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	38122
Q1	217256.5
median	698644
Q3	1964839
95-th percentile	8090033
Maximum	170742992
Range	170742992
Interquartile range (IQR)	1747582.5

Descriptive statistics

Standard deviation	4912980.201
Coefficient of variation (CV)	2.391076512
Kurtosis	166.2331512
Mean	2054714.76
Median Absolute Deviation (MAD)	585834
Skewness	9.633062256
Sum	5.050283409 × 10¹⁰
Variance	2.413737446 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	58	0.1%
28786	51	0.1%
38511	47	0.1%
19450	43	0.1%
57961	39	0.1%
77022	34	0.1%
96472	31	0.1%
24896	29	0.1%
30731	29	0.1%
35788	28	0.1%
Other values (9498)	24190	43.2%
(Missing)	31421	56.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	58	0.1%
389	3	< 0.1%
778	2	< 0.1%
1167	3	< 0.1%
1945	4	< 0.1%
2334	1	< 0.1%
2723	1	< 0.1%
3501	3	< 0.1%
3890	4	< 0.1%
4279	5	< 0.1%

Value	Count	Frequency (%)
170742992	1	< 0.1%
128644634	1	< 0.1%
121124875	1	< 0.1%
108824695	1	< 0.1%
97768148	1	< 0.1%
94410300	1	< 0.1%
90733083	1	< 0.1%
85618511	1	< 0.1%
84875132	1	< 0.1%
84079238	1	< 0.1%

form_field12
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	16778
Distinct (%)	36.4%
Missing	9895
Missing (%)	17.7%
Infinite	0
Infinite (%)	0.0%
Mean	2771112.63

Minimum	0
Maximum	124043931
Zeros	3583
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	275801
median	1163110
Q3	3360182
95-th percentile	10771721.2
Maximum	124043931
Range	124043931
Interquartile range (IQR)	3084381

Descriptive statistics

Standard deviation	4544838.301
Coefficient of variation (CV)	1.640077076
Kurtosis	45.78285755
Mean	2771112.63
Median Absolute Deviation (MAD)	1056913
Skewness	4.73446183
Sum	1.277621478 × 10¹¹
Variance	2.065555518 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3583	6.4%
106975	33	0.1%
389	32	0.1%
3112	32	0.1%
28786	31	0.1%
192944	29	0.1%
778	29	0.1%
15171	27	< 0.1%
38122	27	< 0.1%
2723	27	< 0.1%
Other values (16768)	42255	75.5%
(Missing)	9895	17.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3583	6.4%
389	32	0.1%
778	29	0.1%
1167	26	< 0.1%
1556	19	< 0.1%
1945	18	< 0.1%
2334	15	< 0.1%
2723	27	< 0.1%
3112	32	0.1%
3501	20	< 0.1%

Value	Count	Frequency (%)
124043931	1	< 0.1%
100355387	1	< 0.1%
93148773	1	< 0.1%
77363542	1	< 0.1%
73689048	1	< 0.1%
72896655	1	< 0.1%
67640487	1	< 0.1%
67458824	1	< 0.1%
66718946	1	< 0.1%
63177101	1	< 0.1%

form_field13
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	21960
Distinct (%)	43.8%
Missing	5889
Missing (%)	10.5%
Infinite	0
Infinite (%)	0.0%
Mean	6009944.124

Minimum	0
Maximum	2457824146
Zeros	9016
Zeros (%)	16.1%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	192166
median	1605792
Q3	5593625.5
95-th percentile	24178684
Maximum	2457824146
Range	2457824146
Interquartile range (IQR)	5401459.5

Descriptive statistics

Standard deviation	23358934.08
Coefficient of variation (CV)	3.88671402
Kurtosis	4860.848413
Mean	6009944.124
Median Absolute Deviation (MAD)	1605792
Skewness	53.66765836
Sum	3.0116431 × 10¹¹
Variance	5.456398015 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9016	16.1%
3112	26	< 0.1%
38511	24	< 0.1%
115533	23	< 0.1%
462521	22	< 0.1%
231455	21	< 0.1%
21395	20	< 0.1%
57961	20	< 0.1%
3501	19	< 0.1%
192944	17	< 0.1%
Other values (21950)	40903	73.0%
(Missing)	5889	10.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9016	16.1%
389	13	< 0.1%
778	6	< 0.1%
1167	10	< 0.1%
1556	3	< 0.1%
1945	7	< 0.1%
2334	8	< 0.1%
2723	9	< 0.1%
3112	26	< 0.1%
3501	19	< 0.1%

Value	Count	Frequency (%)
2457824146	1	< 0.1%
2357486653	1	< 0.1%
1396617364	1	< 0.1%
926070905	1	< 0.1%
810694283	1	< 0.1%
662698455	1	< 0.1%
578262115	1	< 0.1%
515642840	1	< 0.1%
510409623	1	< 0.1%
503793900	1	< 0.1%

form_field14
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	1237
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69148750.5

Minimum	0
Maximum	3.854989996 × 10¹¹
Zeros	1446
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	7937934
Q1	16576457
median	28141427
Q3	48187375
95-th percentile	96375139
Maximum	3.854989996 × 10¹¹
Range	3.854989996 × 10¹¹
Interquartile range (IQR)	31610918

Descriptive statistics

Standard deviation	2713995027
Coefficient of variation (CV)	39.24864885
Kurtosis	15527.39332
Mean	69148750.5
Median Absolute Deviation (MAD)	11564970
Skewness	118.5474777
Sum	3.872330028 × 10¹²
Variance	7.365769006 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48187375	5021	9.0%
34694910	5000	8.9%
16576457	4427	7.9%
21973443	4124	7.4%
28141427	4087	7.3%
11564970	3111	5.6%
38549900	2481	4.4%
77099800	2329	4.2%
9637475	1791	3.2%
96375139	1720	3.1%
Other values (1227)	21909	39.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1446	2.6%
389	28	0.1%
1167	48	0.1%
1556	1	< 0.1%
4279	1	< 0.1%
7780	1	< 0.1%
9725	1	< 0.1%
11670	1	< 0.1%
12448	2	< 0.1%
14004	1	< 0.1%

Value	Count	Frequency (%)
3.854989996 × 10¹¹	2	< 0.1%
1.927495 × 10¹¹	1	< 0.1%
1.662112941 × 10¹¹	1	< 0.1%
1.5421502 × 10¹¹	1	< 0.1%
1.333055542 × 10¹¹	1	< 0.1%
5.782485 × 10¹⁰	1	< 0.1%
5.2427864 × 10¹⁰	1	< 0.1%
3.85499 × 10¹⁰	1	< 0.1%
2.8912425 × 10¹⁰	1	< 0.1%
1.06012225 × 10¹⁰	1	< 0.1%

form_field15
Real number (ℝ_≥0)

MISSING

Distinct	23783
Distinct (%)	70.9%
Missing	22475
Missing (%)	40.1%
Infinite	0
Infinite (%)	0.0%
Mean	114504142.6

Minimum	539543
Maximum	3456118736
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	539543
5-th percentile	18024781.8
Q1	50076359
median	84424281
Q3	142873476
95-th percentile	298761725
Maximum	3456118736
Range	3455579193
Interquartile range (IQR)	92797117

Descriptive statistics

Standard deviation	115384236
Coefficient of variation (CV)	1.007686127
Kurtosis	76.52747192
Mean	114504142.6
Median Absolute Deviation (MAD)	41595381
Skewness	5.533132258
Sum	3.838751381 × 10¹²
Variance	1.331352192 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
115649700	75	0.1%
134924650	74	0.1%
77099800	65	0.1%
53969860	63	0.1%
96374750	63	0.1%
48187375	63	0.1%
173474550	60	0.1%
82882285	57	0.1%
57824850	57	0.1%
159982085	56	0.1%
Other values (23773)	32892	58.7%
(Missing)	22475	40.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
539543	1	< 0.1%
951883	1	< 0.1%
1490648	1	< 0.1%
1501151	1	< 0.1%
1812740	1	< 0.1%
1830245	1	< 0.1%
1851640	1	< 0.1%
1892096	1	< 0.1%
1899487	1	< 0.1%
2028246	1	< 0.1%

Value	Count	Frequency (%)
3456118736	1	< 0.1%
3042440187	1	< 0.1%
2926750031	1	< 0.1%
2541598408	1	< 0.1%
2322019967	1	< 0.1%
1754020450	1	< 0.1%
1691377057	1	< 0.1%
1670837857	1	< 0.1%
1646753700	1	< 0.1%
1598278854	1	< 0.1%

form_field16
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	13036
Missing (%)	23.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.2304254725

Minimum	0
Maximum	11
Zeros	35943
Zeros (%)	64.2%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.6218332772
Coefficient of variation (CV)	2.6986308
Kurtosis	24.49731266
Mean	0.2304254725
Median Absolute Deviation (MAD)	0
Skewness	3.999874977
Sum	9900
Variance	0.3866766246
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	35943	64.2%
1	5123	9.1%
2	1290	2.3%
3	383	0.7%
4	139	0.2%
5	50	0.1%
6	23	< 0.1%
7	8	< 0.1%
8	2	< 0.1%
11	2	< 0.1%
(Missing)	13036	23.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35943	64.2%
1	5123	9.1%
2	1290	2.3%
3	383	0.7%
4	139	0.2%
5	50	0.1%
6	23	< 0.1%
7	8	< 0.1%
8	2	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
11	2	< 0.1%
10	1	< 0.1%
8	2	< 0.1%
7	8	< 0.1%
6	23	< 0.1%
5	50	0.1%
4	139	0.2%
3	383	0.7%
2	1290	2.3%
1	5123	9.1%

form_field17
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	15
Distinct (%)	< 0.1%
Missing	11151
Missing (%)	19.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.2656915427

Minimum	0
Maximum	21
Zeros	36859
Zeros (%)	65.8%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7201984266
Coefficient of variation (CV)	2.710656196
Kurtosis	50.98296348
Mean	0.2656915427
Median Absolute Deviation (MAD)	0
Skewness	5.044449793
Sum	11916
Variance	0.5186857737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	36859	65.8%
1	5653	10.1%
2	1488	2.7%
3	489	0.9%
4	193	0.3%
5	87	0.2%
6	29	0.1%
7	23	< 0.1%
8	11	< 0.1%
9	6	< 0.1%
Other values (5)	11	< 0.1%
(Missing)	11151	19.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	36859	65.8%
1	5653	10.1%
2	1488	2.7%
3	489	0.9%
4	193	0.3%
5	87	0.2%
6	29	0.1%
7	23	< 0.1%
8	11	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
16	1	< 0.1%
13	2	< 0.1%
11	3	< 0.1%
10	4	< 0.1%
9	6	< 0.1%
8	11	< 0.1%
7	23	< 0.1%
6	29	0.1%
5	87	0.2%

form_field18
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	16
Distinct (%)	< 0.1%
Missing	10402
Missing (%)	18.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.2718320979

Minimum	0
Maximum	21
Zeros	37265
Zeros (%)	66.5%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7254342304
Coefficient of variation (CV)	2.668684957
Kurtosis	49.52661382
Mean	0.2718320979
Median Absolute Deviation (MAD)	0
Skewness	4.96600487
Sum	12395
Variance	0.5262548226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	37265	66.5%
1	5909	10.6%
2	1546	2.8%
3	508	0.9%
4	200	0.4%
5	85	0.2%
6	33	0.1%
7	24	< 0.1%
8	11	< 0.1%
9	6	< 0.1%
Other values (6)	11	< 0.1%
(Missing)	10402	18.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37265	66.5%
1	5909	10.6%
2	1546	2.8%
3	508	0.9%
4	200	0.4%
5	85	0.2%
6	33	0.1%
7	24	< 0.1%
8	11	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
16	1	< 0.1%
13	2	< 0.1%
12	1	< 0.1%
11	2	< 0.1%
10	4	< 0.1%
9	6	< 0.1%
8	11	< 0.1%
7	24	< 0.1%
6	33	0.1%

form_field19
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	26
Distinct (%)	< 0.1%
Missing	4
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.9487999143

Minimum	0
Maximum	28
Zeros	33598
Zeros (%)	60.0%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	4
Maximum	28
Range	28
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.736454134
Coefficient of variation (CV)	1.830158401
Kurtosis	18.23815699
Mean	0.9487999143
Median Absolute Deviation (MAD)	0
Skewness	3.327069868
Sum	53129
Variance	3.015272959
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0	33598	60.0%
1	10233	18.3%
2	5108	9.1%
3	2865	5.1%
4	1615	2.9%
5	956	1.7%
6	589	1.1%
7	371	0.7%
8	217	0.4%
9	160	0.3%
Other values (16)	284	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33598	60.0%
1	10233	18.3%
2	5108	9.1%
3	2865	5.1%
4	1615	2.9%
5	956	1.7%
6	589	1.1%
7	371	0.7%
8	217	0.4%
9	160	0.3%

Value	Count	Frequency (%)
28	2	< 0.1%
25	1	< 0.1%
24	1	< 0.1%
22	1	< 0.1%
21	4	< 0.1%
20	6	< 0.1%
19	3	< 0.1%
18	4	< 0.1%
17	8	< 0.1%
16	5	< 0.1%

form_field20
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	27
Distinct (%)	< 0.1%
Missing	355
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.031593135

Minimum	0
Maximum	29
Zeros	31471
Zeros (%)	56.2%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	5
Maximum	29
Range	29
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.785121594
Coefficient of variation (CV)	1.730451215
Kurtosis	16.7830518
Mean	1.031593135
Median Absolute Deviation (MAD)	0
Skewness	3.174998642
Sum	57403
Variance	3.186659106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	31471	56.2%
1	11000	19.6%
2	5569	9.9%
3	3030	5.4%
4	1791	3.2%
5	1040	1.9%
6	630	1.1%
7	394	0.7%
8	248	0.4%
9	169	0.3%
Other values (17)	303	0.5%
(Missing)	355	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	31471	56.2%
1	11000	19.6%
2	5569	9.9%
3	3030	5.4%
4	1791	3.2%
5	1040	1.9%
6	630	1.1%
7	394	0.7%
8	248	0.4%
9	169	0.3%

Value	Count	Frequency (%)
29	1	< 0.1%
28	1	< 0.1%
25	1	< 0.1%
24	1	< 0.1%
22	1	< 0.1%
21	4	< 0.1%
20	6	< 0.1%
19	4	< 0.1%
18	4	< 0.1%
17	7	< 0.1%

form_field21
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	11101
Distinct (%)	27.7%
Missing	15854
Missing (%)	28.3%
Infinite	0
Infinite (%)	0.0%
Mean	86.50037999

Minimum	0.255
Maximum	1957.875
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0.255
5-th percentile	7.83
Q1	40.305
median	89.1675
Q3	129.8925
95-th percentile	155.25
Maximum	1957.875
Range	1957.62
Interquartile range (IQR)	89.5875

Descriptive statistics

Standard deviation	53.44552806
Coefficient of variation (CV)	0.6178646622
Kurtosis	43.54744654
Mean	86.50037999
Median Absolute Deviation (MAD)	44.0475
Skewness	1.714099871
Sum	3472644.255
Variance	2856.424469
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	98	0.2%
37.5	39	0.1%
148.5	36	0.1%
147	36	0.1%
141	33	0.1%
142.5	31	0.1%
138	28	0.1%
136.5	28	0.1%
135	27	< 0.1%
145.5	27	< 0.1%
Other values (11091)	39763	71.0%
(Missing)	15854	28.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.255	2	< 0.1%
0.375	3	< 0.1%
0.39	2	< 0.1%
0.405	1	< 0.1%
0.435	3	< 0.1%
0.45	2	< 0.1%
0.465	1	< 0.1%
0.51	1	< 0.1%
0.57	1	< 0.1%
0.585	1	< 0.1%

Value	Count	Frequency (%)
1957.875	1	< 0.1%
1092	1	< 0.1%
908.25	1	< 0.1%
708.12	1	< 0.1%
626.07	1	< 0.1%
610.8	1	< 0.1%
582.6	1	< 0.1%
567.255	1	< 0.1%
548.19	1	< 0.1%
534	1	< 0.1%

form_field22
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	23583
Distinct (%)	66.2%
Missing	20400
Missing (%)	36.4%
Infinite	0
Infinite (%)	0.0%
Mean	6628.316381

Minimum	0
Maximum	97200
Zeros	5205
Zeros (%)	9.3%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1068.6675
median	5976.225
Q3	11354.17125
95-th percentile	15110.30625
Maximum	97200
Range	97200
Interquartile range (IQR)	10285.50375

Descriptive statistics

Standard deviation	5661.059297
Coefficient of variation (CV)	0.8540719802
Kurtosis	3.4540262
Mean	6628.316381
Median Absolute Deviation (MAD)	5087.7375
Skewness	0.7990557295
Sum	235968063.2
Variance	32047592.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5205	9.3%
15000	153	0.3%
3750	39	0.1%
14850	30	0.1%
14700	29	0.1%
13200	26	< 0.1%
13950	25	< 0.1%
13800	24	< 0.1%
12000	24	< 0.1%
12300	24	< 0.1%
Other values (23573)	30021	53.6%
(Missing)	20400	36.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5205	9.3%
0.045	1	< 0.1%
0.51	2	< 0.1%
0.795	1	< 0.1%
0.915	1	< 0.1%
0.945	1	< 0.1%
1.005	1	< 0.1%
1.05	1	< 0.1%
1.11	1	< 0.1%
1.935	1	< 0.1%

Value	Count	Frequency (%)
97200	1	< 0.1%
73956	1	< 0.1%
62606.25	1	< 0.1%
62025	1	< 0.1%
58260	1	< 0.1%
54819.225	1	< 0.1%
54409.995	1	< 0.1%
53340	1	< 0.1%
52639.995	1	< 0.1%
51537	1	< 0.1%

form_field23
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	16619
Distinct (%)	59.6%
Missing	28123
Missing (%)	50.2%
Infinite	0
Infinite (%)	0.0%
Mean	6452.875072

Minimum	0
Maximum	97200
Zeros	4785
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	797.145
median	5548.935
Q3	11280
95-th percentile	15144.78
Maximum	97200
Range	97200
Interquartile range (IQR)	10482.855

Descriptive statistics

Standard deviation	5739.968774
Coefficient of variation (CV)	0.8895211376
Kurtosis	4.110465526
Mean	6452.875072
Median Absolute Deviation (MAD)	5093.43
Skewness	0.9010395197
Sum	179886798.4
Variance	32947241.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4785	8.5%
15000	119	0.2%
3750	52	0.1%
14700	32	0.1%
14400	26	< 0.1%
12000	26	< 0.1%
13800	23	< 0.1%
14100	23	< 0.1%
13500	23	< 0.1%
14850	22	< 0.1%
Other values (16609)	22746	40.6%
(Missing)	28123	50.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4785	8.5%
0.045	1	< 0.1%
0.645	1	< 0.1%
0.795	1	< 0.1%
1.065	1	< 0.1%
1.11	1	< 0.1%
1.245	1	< 0.1%
2.1	1	< 0.1%
2.4	1	< 0.1%
2.505	1	< 0.1%

Value	Count	Frequency (%)
97200	1	< 0.1%
72060	1	< 0.1%
62606.25	1	< 0.1%
62025	1	< 0.1%
58260	1	< 0.1%
54819.225	1	< 0.1%
53340	1	< 0.1%
52639.995	1	< 0.1%
51537	1	< 0.1%
51510	1	< 0.1%

form_field24
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	12571
Distinct (%)	29.4%
Missing	13297
Missing (%)	23.7%
Infinite	0
Infinite (%)	0.0%
Mean	104.558516

Minimum	0
Maximum	31863.75
Zeros	3262
Zeros (%)	5.8%
Negative	0
Negative (%)	0.0%
Memory size	437.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	14.865
median	60.66
Q3	114.7125
95-th percentile	198.627
Maximum	31863.75
Range	31863.75
Interquartile range (IQR)	99.8475

Descriptive statistics

Standard deviation	436.670719
Coefficient of variation (CV)	4.176328582
Kurtosis	1522.146068
Mean	104.558516
Median Absolute Deviation (MAD)	48.63
Skewness	30.44013754
Sum	4464962.31
Variance	190681.3168
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3262	5.8%
150	44	0.1%
0.03	29	0.1%
0.045	28	0.1%
0.135	27	< 0.1%
0.12	23	< 0.1%
0.105	23	< 0.1%
0.165	22	< 0.1%
0.015	22	< 0.1%
144	22	< 0.1%
Other values (12561)	39201	70.0%
(Missing)	13297	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3262	5.8%
0.015	22	< 0.1%
0.03	29	0.1%
0.045	28	0.1%
0.06	19	< 0.1%
0.075	20	< 0.1%
0.09	22	< 0.1%
0.105	23	< 0.1%
0.12	23	< 0.1%
0.135	27	< 0.1%

Value	Count	Frequency (%)
31863.75	1	< 0.1%
30227.505	1	< 0.1%
16089.75	1	< 0.1%
15007.95	1	< 0.1%
14856	1	< 0.1%
14220.495	1	< 0.1%
13630.995	1	< 0.1%
13047.03	1	< 0.1%
13019.7	1	< 0.1%
13011.495	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Applicant_ID	form_field1	form_field2	form_field3	form_field5	form_field6	form_field7	form_field8	form_field9	form_field10	form_field11	form_field12	form_field13	form_field14	form_field15	form_field16	form_field17	form_field18	form_field19	form_field20	form_field21	form_field22	form_field23	form_field24
0	Apcnt_1000000	3436.0	0.28505	1.6560	0.0000	0.0	10689720.0	252072.0	4272776.0	11333126.0	4397256.0	2301324.0	7875694.0	96375139	112181765.0	1.0	1.0	1.0	3.0	3.0	134.655	NaN	NaN	134.655
1	Apcnt_1000004	3456.0	0.67400	0.2342	0.0000	0.0	898979.0	497531.0	9073814.0	2533168.0	244292.0	3982971.0	2141445.0	28141427	45169902.0	1.0	1.0	1.0	2.0	2.0	109.230	11385.240	14584.29	86.685
2	Apcnt_1000008	3276.0	0.53845	3.1510	6.2820	NaN	956940.0	NaN	192944.0	1079864.0	NaN	NaN	0.0	16576457	22452691.0	NaN	NaN	NaN	0.0	0.0	NaN	NaN	NaN	NaN
3	Apcnt_1000012	3372.0	0.17005	0.5050	0.0000	192166.0	3044703.0	385499.0	3986472.0	3621979.0	NaN	771776.0	1186839.0	48187375	136297820.0	0.0	0.0	0.0	1.0	1.0	120.120	8580.000	0.00	85.800
4	Apcnt_1000016	3370.0	0.77270	1.1010	0.0000	1556.0	214728.0	214728.0	1284089.0	361770.0	396391.0	818456.0	511535.0	28141427	15292757.0	0.0	0.0	0.0	3.0	3.0	104.535	8360.190	10326.45	115.335
5	Apcnt_1000020	3724.0	NaN	0.0000	0.0000	192944.0	9244585.0	6761209.0	67963357.0	32902009.0	NaN	976390.0	2114215.0	16576457	NaN	0.0	0.0	0.0	0.0	0.0	8.385	NaN	NaN	4.845
6	Apcnt_1000024	3350.0	0.24205	0.3132	2.8188	NaN	580388.0	NaN	96472.0	580388.0	631347.0	NaN	0.0	21973443	91602498.0	NaN	NaN	NaN	0.0	0.0	NaN	NaN	NaN	NaN
7	Apcnt_1000028	3416.0	0.87020	0.0570	0.0000	17505.0	186331.0	186331.0	1484813.0	326760.0	50959.0	1284089.0	5633109.0	11564970	18211813.0	0.0	0.0	0.0	1.0	1.0	124.980	8267.655	7755.00	82.680
8	Apcnt_1000036	3376.0	0.29180	0.5586	0.0000	18283.0	1105149.0	18283.0	115533.0	1557167.0	752715.0	97639.0	427511.0	11564970	NaN	0.0	0.0	0.0	1.0	2.0	126.495	NaN	NaN	126.495
9	Apcnt_1000040	3310.0	0.24395	0.1562	0.0000	NaN	0.0	NaN	NaN	0.0	208115.0	NaN	NaN	11564970	NaN	NaN	NaN	NaN	0.0	0.0	NaN	NaN	NaN	NaN

Last rows

	Applicant_ID	form_field1	form_field2	form_field3	form_field4	form_field6	form_field7	form_field8	form_field9	form_field10	form_field11	form_field12	form_field13	form_field14	form_field15	form_field16	form_field17	form_field18	form_field19	form_field20	form_field21	form_field22	form_field23	form_field24
55990	Apcnt_999944	3600.0	0.50335	0.0000	0.0000	755049.0	12006096.0	1927495.0	40139743.0	44192734.0	NaN	13006993.0	9823417.0	96375139	196604490.0	0.0	0.0	0.0	2.0	3.0	109.965	11474.715	3853.41	88.815
55991	Apcnt_999948	NaN	0.22670	0.0000	0.0000	NaN	NaN	NaN	NaN	0.0	5994101.0	NaN	NaN	9637475	NaN	NaN	NaN	NaN	0.0	0.0	NaN	NaN	NaN	NaN
55992	Apcnt_999952	3504.0	0.39085	0.0980	0.0000	4279.0	500254.0	80912.0	2819472.0	1004787.0	NaN	1173613.0	634070.0	48187375	80632309.0	0.0	1.0	1.0	4.0	4.0	132.255	9003.840	NaN	99.255
55993	Apcnt_999960	3556.0	0.69340	0.0736	0.0000	96472.0	3469491.0	3469491.0	28291192.0	21997172.0	NaN	2929170.0	1270085.0	21973443	39441488.0	0.0	0.0	0.0	1.0	3.0	61.575	7531.800	318.75	28.830
55994	Apcnt_999964	NaN	0.01465	0.0000	0.0000	NaN	NaN	NaN	NaN	0.0	NaN	NaN	NaN	34694910	NaN	NaN	NaN	NaN	0.0	0.0	NaN	NaN	NaN	NaN
55995	Apcnt_999968	3740.0	0.01730	0.0000	0.0000	770998.0	9637475.0	4047934.0	11641992.0	19910965.0	NaN	983003.0	25985589.0	48187375	86615907.0	0.0	0.0	0.0	0.0	0.0	31.740	1662.150	0.00	15.810
55996	Apcnt_999972	3360.0	2.01145	0.6252	0.0000	NaN	927765.0	NaN	NaN	1849306.0	571052.0	NaN	0.0	16576457	NaN	NaN	NaN	0.0	0.0	1.0	NaN	13350.000	NaN	NaN
55997	Apcnt_999980	3500.0	0.76640	0.0000	0.0000	118645.0	3662435.0	3662435.0	3585024.0	704090.0	NaN	2765401.0	4226874.0	21973443	87508273.0	0.0	0.0	0.0	2.0	2.0	119.565	2206.950	12690.00	119.565
55998	Apcnt_999988	3280.0	0.05235	2.0916	2.2212	NaN	3458599.0	NaN	115533.0	3458599.0	508812.0	NaN	0.0	38549900	20238892.0	NaN	NaN	NaN	0.0	0.0	NaN	NaN	NaN	NaN
55999	Apcnt_999996	3522.0	0.46930	0.0000	0.0000	98806.0	2053920.0	523983.0	14903368.0	5430440.0	NaN	8381783.0	5490346.0	21973443	38370960.0	0.0	0.0	0.0	3.0	3.0	116.445	1680.000	1680.00	93.825

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows